Tabela CO_SUBSCRIPTIONPERSON

Definicja tabeli CO_SUBSCRIPTIONPERSON

Name

CO_SUBSCRIPTIONPERSON

Code

CO_SUBSCRIPTIONPERSON

Comment

 


Lista kolumn tabeli CO_SUBSCRIPTIONPERSON

Name

Code

CO_SUBSCRIPTIONPERSONID

CO_SUBSCRIPTIONPERSONID

NAME

NAME

SURNAME

SURNAME

NOTE

NOTE

PERSONNUMBER

PERSONNUMBER

CO_DICTCONSUMERID

CO_DICTCONSUMERID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_SUBSCRIPTIONPERSONID tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny CO_SUBSCRIPTIONPERSONID tabeli CO_SUBSCRIPTIONPERSON

Name

CO_SUBSCRIPTIONPERSONID

Code

CO_SUBSCRIPTIONPERSONID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NAME tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny NAME tabeli CO_SUBSCRIPTIONPERSON

Name

NAME

Code

NAME

Data Type

VARCHAR2(40)

Mandatory

Yes

Comment

 


Kolumna SURNAME tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny SURNAME tabeli CO_SUBSCRIPTIONPERSON

Name

SURNAME

Code

SURNAME

Data Type

VARCHAR2(60)

Mandatory

Yes

Comment

 


Kolumna NOTE tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny NOTE tabeli CO_SUBSCRIPTIONPERSON

Name

NOTE

Code

NOTE

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna PERSONNUMBER tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny PERSONNUMBER tabeli CO_SUBSCRIPTIONPERSON

Name

PERSONNUMBER

Code

PERSONNUMBER

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna CO_DICTCONSUMERID tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny CO_DICTCONSUMERID tabeli CO_SUBSCRIPTIONPERSON

Name

CO_DICTCONSUMERID

Code

CO_DICTCONSUMERID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna INSERTDATE tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny INSERTDATE tabeli CO_SUBSCRIPTIONPERSON

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny INSERTINGPERSON tabeli CO_SUBSCRIPTIONPERSON

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_SUBSCRIPTIONPERSON

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_SUBSCRIPTIONPERSON

Definicja kolumny LASTMODIFIEDDT tabeli CO_SUBSCRIPTIONPERSON

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_SUBSCRIPTIONPERSON

Name

Code

Primary

PK_CO_SUBSCRIPTIONPERSON

PK_CO_SUBSCRIPTIONPERSON

X


Klucz PK_CO_SUBSCRIPTIONPERSON tabeli CO_SUBSCRIPTIONPERSON

Definicja klucza PK_CO_SUBSCRIPTIONPERSON tabeli CO_SUBSCRIPTIONPERSON

Name

PK_CO_SUBSCRIPTIONPERSON

Code

PK_CO_SUBSCRIPTIONPERSON

Primary

Yes

Comment